Overview
Brought to you by YData
Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 2823 |
| Missing cells | 5157 |
| Missing cells (%) | 7.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 551.5 KiB |
| Average record size in memory | 200.0 B |
Variable types
| Numeric | 7 |
|---|---|
| DateTime | 1 |
| Categorical | 9 |
| Text | 8 |
ADDRESSLINE2 is highly overall correlated with COUNTRY and 4 other fields | High correlation |
COUNTRY is highly overall correlated with ADDRESSLINE2 and 2 other fields | High correlation |
DEALSIZE is highly overall correlated with SALES | High correlation |
MONTH_ID is highly overall correlated with QTR_ID | High correlation |
MSRP is highly overall correlated with PRICEEACH and 1 other fields | High correlation |
ORDERNUMBER is highly overall correlated with ADDRESSLINE2 and 2 other fields | High correlation |
PRICEEACH is highly overall correlated with MSRP and 1 other fields | High correlation |
QTR_ID is highly overall correlated with MONTH_ID and 1 other fields | High correlation |
QUANTITYORDERED is highly overall correlated with SALES | High correlation |
SALES is highly overall correlated with DEALSIZE and 3 other fields | High correlation |
STATE is highly overall correlated with ADDRESSLINE2 and 2 other fields | High correlation |
TERRITORY is highly overall correlated with ADDRESSLINE2 and 2 other fields | High correlation |
YEAR_ID is highly overall correlated with ADDRESSLINE2 and 1 other fields | High correlation |
STATUS is highly imbalanced (79.2%) | Imbalance |
ADDRESSLINE2 has 2521 (89.3%) missing values | Missing |
STATE has 1486 (52.6%) missing values | Missing |
POSTALCODE has 76 (2.7%) missing values | Missing |
TERRITORY has 1074 (38.0%) missing values | Missing |
Reproduction
| Analysis started | 2025-08-08 09:20:52.465429 |
|---|---|
| Analysis finished | 2025-08-08 09:20:57.923321 |
| Duration | 5.46 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
ORDERNUMBER
Real number (ℝ)
High correlation
| Distinct | 307 |
|---|---|
| Distinct (%) | 10.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10258.725 |
| Minimum | 10100 |
|---|---|
| Maximum | 10425 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.2 KiB |
Quantile statistics
| Minimum | 10100 |
|---|---|
| 5-th percentile | 10115 |
| Q1 | 10180 |
| median | 10262 |
| Q3 | 10333.5 |
| 95-th percentile | 10405 |
| Maximum | 10425 |
| Range | 325 |
| Interquartile range (IQR) | 153.5 |
Descriptive statistics
| Standard deviation | 92.085478 |
|---|---|
| Coefficient of variation (CV) | 0.0089763081 |
| Kurtosis | -1.1733092 |
| Mean | 10258.725 |
| Median Absolute Deviation (MAD) | 79 |
| Skewness | 0.013822989 |
| Sum | 28960381 |
| Variance | 8479.7352 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10386 | 18 | 0.6% |
| 10398 | 18 | 0.6% |
| 10222 | 18 | 0.6% |
| 10106 | 18 | 0.6% |
| 10159 | 18 | 0.6% |
| 10168 | 18 | 0.6% |
| 10332 | 18 | 0.6% |
| 10275 | 18 | 0.6% |
| 10165 | 18 | 0.6% |
| 10316 | 18 | 0.6% |
| Other values (297) | 2643 |
| Value | Count | Frequency (%) |
| 10100 | 4 | 0.1% |
| 10101 | 4 | 0.1% |
| 10102 | 2 | 0.1% |
| 10103 | 16 | |
| 10104 | 13 | |
| 10105 | 15 | |
| 10106 | 18 | |
| 10107 | 8 | |
| 10108 | 16 | |
| 10109 | 6 | 0.2% |
| Value | Count | Frequency (%) |
| 10425 | 13 | |
| 10424 | 6 | |
| 10423 | 5 | 0.2% |
| 10422 | 2 | 0.1% |
| 10421 | 2 | 0.1% |
| 10420 | 13 | |
| 10419 | 14 | |
| 10417 | 6 | |
| 10416 | 14 | |
| 10415 | 5 | 0.2% |
QUANTITYORDERED
Real number (ℝ)
High correlation
| Distinct | 58 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.092809 |
| Minimum | 6 |
|---|---|
| Maximum | 97 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.2 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 21 |
| Q1 | 27 |
| median | 35 |
| Q3 | 43 |
| 95-th percentile | 49 |
| Maximum | 97 |
| Range | 91 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 9.7414427 |
|---|---|
| Coefficient of variation (CV) | 0.27759085 |
| Kurtosis | 0.41574379 |
| Mean | 35.092809 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.36258533 |
| Sum | 99067 |
| Variance | 94.895707 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 34 | 112 | 4.0% |
| 21 | 103 | 3.6% |
| 46 | 101 | 3.6% |
| 27 | 100 | 3.5% |
| 45 | 97 | 3.4% |
| 41 | 97 | 3.4% |
| 31 | 97 | 3.4% |
| 26 | 96 | 3.4% |
| 29 | 94 | 3.3% |
| 48 | 94 | 3.3% |
| Other values (48) | 1832 |
| Value | Count | Frequency (%) |
| 6 | 2 | 0.1% |
| 10 | 2 | 0.1% |
| 11 | 2 | 0.1% |
| 12 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 15 | 4 | 0.1% |
| 16 | 1 | < 0.1% |
| 18 | 3 | 0.1% |
| 19 | 3 | 0.1% |
| 20 | 93 |
| Value | Count | Frequency (%) |
| 97 | 1 | < 0.1% |
| 85 | 1 | < 0.1% |
| 77 | 1 | < 0.1% |
| 76 | 3 | |
| 70 | 2 | 0.1% |
| 66 | 5 | |
| 65 | 1 | < 0.1% |
| 64 | 3 | |
| 62 | 1 | < 0.1% |
| 61 | 3 |
PRICEEACH
Real number (ℝ)
High correlation
| Distinct | 1016 |
|---|---|
| Distinct (%) | 36.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 83.658544 |
| Minimum | 26.88 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.2 KiB |
Quantile statistics
| Minimum | 26.88 |
|---|---|
| 5-th percentile | 42.67 |
| Q1 | 68.86 |
| median | 95.7 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 73.12 |
| Interquartile range (IQR) | 31.14 |
Descriptive statistics
| Standard deviation | 20.174277 |
|---|---|
| Coefficient of variation (CV) | 0.24115022 |
| Kurtosis | -0.37481769 |
| Mean | 83.658544 |
| Median Absolute Deviation (MAD) | 4.3 |
| Skewness | -0.94664886 |
| Sum | 236168.07 |
| Variance | 407.00143 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 100 | 1304 | |
| 96.34 | 6 | 0.2% |
| 59.87 | 6 | 0.2% |
| 89.38 | 5 | 0.2% |
| 90.17 | 5 | 0.2% |
| 67.14 | 5 | 0.2% |
| 57.73 | 5 | 0.2% |
| 61.99 | 5 | 0.2% |
| 51.93 | 5 | 0.2% |
| 80.55 | 5 | 0.2% |
| Other values (1006) | 1472 |
| Value | Count | Frequency (%) |
| 26.88 | 1 | < 0.1% |
| 27.22 | 1 | < 0.1% |
| 28.29 | 1 | < 0.1% |
| 28.88 | 1 | < 0.1% |
| 29.21 | 2 | |
| 29.54 | 3 | |
| 29.7 | 1 | < 0.1% |
| 29.87 | 1 | < 0.1% |
| 30.06 | 2 | |
| 30.2 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 1304 | |
| 99.91 | 1 | < 0.1% |
| 99.82 | 2 | 0.1% |
| 99.72 | 1 | < 0.1% |
| 99.69 | 1 | < 0.1% |
| 99.67 | 1 | < 0.1% |
| 99.66 | 1 | < 0.1% |
| 99.58 | 1 | < 0.1% |
| 99.57 | 1 | < 0.1% |
| 99.55 | 2 | 0.1% |
ORDERLINENUMBER
Real number (ℝ)
| Distinct | 18 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.4661707 |
| Minimum | 1 |
|---|---|
| Maximum | 18 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 14 |
| Maximum | 18 |
| Range | 17 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.225841 |
|---|---|
| Coefficient of variation (CV) | 0.65353068 |
| Kurtosis | -0.56115424 |
| Mean | 6.4661707 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.59074121 |
| Sum | 18254 |
| Variance | 17.857732 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=18)
| Value | Count | Frequency (%) |
| 1 | 307 | |
| 2 | 291 | |
| 3 | 270 | |
| 4 | 256 | |
| 5 | 239 | |
| 6 | 221 | |
| 7 | 197 | 7.0% |
| 8 | 187 | 6.6% |
| 9 | 165 | 5.8% |
| 10 | 141 | 5.0% |
| Other values (8) | 549 |
| Value | Count | Frequency (%) |
| 1 | 307 | |
| 2 | 291 | |
| 3 | 270 | |
| 4 | 256 | |
| 5 | 239 | |
| 6 | 221 | |
| 7 | 197 | |
| 8 | 187 | |
| 9 | 165 | |
| 10 | 141 |
| Value | Count | Frequency (%) |
| 18 | 10 | 0.4% |
| 17 | 25 | 0.9% |
| 16 | 42 | 1.5% |
| 15 | 56 | 2.0% |
| 14 | 81 | |
| 13 | 97 | |
| 12 | 110 | |
| 11 | 128 | |
| 10 | 141 | |
| 9 | 165 |
SALES
Real number (ℝ)
High correlation
| Distinct | 2763 |
|---|---|
| Distinct (%) | 97.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3553.8891 |
| Minimum | 482.13 |
|---|---|
| Maximum | 14082.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.2 KiB |
Quantile statistics
| Minimum | 482.13 |
|---|---|
| 5-th percentile | 1268.757 |
| Q1 | 2203.43 |
| median | 3184.8 |
| Q3 | 4508 |
| 95-th percentile | 7108.12 |
| Maximum | 14082.8 |
| Range | 13600.67 |
| Interquartile range (IQR) | 2304.57 |
Descriptive statistics
| Standard deviation | 1841.8651 |
|---|---|
| Coefficient of variation (CV) | 0.51826747 |
| Kurtosis | 1.7926765 |
| Mean | 3553.8891 |
| Median Absolute Deviation (MAD) | 1102.31 |
| Skewness | 1.161076 |
| Sum | 10032629 |
| Variance | 3392467.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3003 | 3 | 0.1% |
| 4181.44 | 2 | 0.1% |
| 2851.54 | 2 | 0.1% |
| 4428 | 2 | 0.1% |
| 2559.6 | 2 | 0.1% |
| 3508.8 | 2 | 0.1% |
| 2702.04 | 2 | 0.1% |
| 5182 | 2 | 0.1% |
| 2173.6 | 2 | 0.1% |
| 3451 | 2 | 0.1% |
| Other values (2753) | 2802 |
| Value | Count | Frequency (%) |
| 482.13 | 1 | |
| 541.14 | 1 | |
| 553.95 | 1 | |
| 577.6 | 1 | |
| 640.05 | 1 | |
| 651.8 | 1 | |
| 652.35 | 1 | |
| 683.8 | 1 | |
| 694.6 | 1 | |
| 703.6 | 1 |
| Value | Count | Frequency (%) |
| 14082.8 | 1 | |
| 12536.5 | 1 | |
| 12001 | 1 | |
| 11887.8 | 1 | |
| 11886.6 | 1 | |
| 11739.7 | 1 | |
| 11623.7 | 1 | |
| 11336.7 | 1 | |
| 11279.2 | 1 | |
| 10993.5 | 1 |
ORDERDATE
Date
| Distinct | 252 |
|---|---|
| Distinct (%) | 8.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 22.2 KiB |
| Minimum | 2003-01-06 00:00:00 |
|---|---|
| Maximum | 2005-05-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
STATUS
Categorical
Imbalance
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 22.2 KiB |
| Shipped | |
|---|---|
| Cancelled | 60 |
| Resolved | 47 |
| On Hold | 44 |
| In Process | 41 |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 7.1076869 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Shipped |
|---|---|
| 2nd row | Shipped |
| 3rd row | Shipped |
| 4th row | Shipped |
| 5th row | Shipped |
Common Values
| Value | Count | Frequency (%) |
| Shipped | 2617 | |
| Cancelled | 60 | 2.1% |
| Resolved | 47 | 1.7% |
| On Hold | 44 | 1.6% |
| In Process | 41 | 1.5% |
| Disputed | 14 | 0.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| shipped | 2617 | |
| cancelled | 60 | 2.1% |
| resolved | 47 | 1.6% |
| on | 44 | 1.5% |
| hold | 44 | 1.5% |
| in | 41 | 1.4% |
| process | 41 | 1.4% |
| disputed | 14 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 5248 | |
| e | 2886 | |
| d | 2782 | |
| i | 2631 | |
| S | 2617 | |
| h | 2617 | |
| l | 211 | 1.1% |
| n | 145 | 0.7% |
| s | 143 | 0.7% |
| o | 132 | 0.7% |
| Other values (14) | 653 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 20065 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| p | 5248 | |
| e | 2886 | |
| d | 2782 | |
| i | 2631 | |
| S | 2617 | |
| h | 2617 | |
| l | 211 | 1.1% |
| n | 145 | 0.7% |
| s | 143 | 0.7% |
| o | 132 | 0.7% |
| Other values (14) | 653 | 3.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 20065 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| p | 5248 | |
| e | 2886 | |
| d | 2782 | |
| i | 2631 | |
| S | 2617 | |
| h | 2617 | |
| l | 211 | 1.1% |
| n | 145 | 0.7% |
| s | 143 | 0.7% |
| o | 132 | 0.7% |
| Other values (14) | 653 | 3.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 20065 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| p | 5248 | |
| e | 2886 | |
| d | 2782 | |
| i | 2631 | |
| S | 2617 | |
| h | 2617 | |
| l | 211 | 1.1% |
| n | 145 | 0.7% |
| s | 143 | 0.7% |
| o | 132 | 0.7% |
| Other values (14) | 653 | 3.3% |
QTR_ID
Categorical
High correlation
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 22.2 KiB |
| 4 | |
|---|---|
| 1 | |
| 2 | |
| 3 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 2 |
| 3rd row | 3 |
| 4th row | 3 |
| 5th row | 4 |
Common Values
| Value | Count | Frequency (%) |
| 4 | 1094 | |
| 1 | 665 | |
| 2 | 561 | |
| 3 | 503 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 4 | 1094 | |
| 1 | 665 | |
| 2 | 561 | |
| 3 | 503 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 1094 | |
| 1 | 665 | |
| 2 | 561 | |
| 3 | 503 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2823 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 1094 | |
| 1 | 665 | |
| 2 | 561 | |
| 3 | 503 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2823 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 1094 | |
| 1 | 665 | |
| 2 | 561 | |
| 3 | 503 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2823 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 1094 | |
| 1 | 665 | |
| 2 | 561 | |
| 3 | 503 |
MONTH_ID
Real number (ℝ)
High correlation
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.0924548 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 8 |
| Q3 | 11 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 3.6566333 |
|---|---|
| Coefficient of variation (CV) | 0.51556667 |
| Kurtosis | -1.3832748 |
| Mean | 7.0924548 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.27290156 |
| Sum | 20022 |
| Variance | 13.370967 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 11 | 597 | |
| 10 | 317 | |
| 5 | 252 | |
| 1 | 229 | 8.1% |
| 2 | 224 | 7.9% |
| 3 | 212 | 7.5% |
| 8 | 191 | 6.8% |
| 12 | 180 | 6.4% |
| 4 | 178 | 6.3% |
| 9 | 171 | 6.1% |
| Other values (2) | 272 |
| Value | Count | Frequency (%) |
| 1 | 229 | |
| 2 | 224 | |
| 3 | 212 | |
| 4 | 178 | |
| 5 | 252 | |
| 6 | 131 | |
| 7 | 141 | |
| 8 | 191 | |
| 9 | 171 | |
| 10 | 317 |
| Value | Count | Frequency (%) |
| 12 | 180 | 6.4% |
| 11 | 597 | |
| 10 | 317 | |
| 9 | 171 | 6.1% |
| 8 | 191 | 6.8% |
| 7 | 141 | 5.0% |
| 6 | 131 | 4.6% |
| 5 | 252 | |
| 4 | 178 | 6.3% |
| 3 | 212 | 7.5% |
YEAR_ID
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 22.2 KiB |
| 2004 | |
|---|---|
| 2003 | |
| 2005 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2003 |
|---|---|
| 2nd row | 2003 |
| 3rd row | 2003 |
| 4th row | 2003 |
| 5th row | 2003 |
Common Values
| Value | Count | Frequency (%) |
| 2004 | 1345 | |
| 2003 | 1000 | |
| 2005 | 478 | 16.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2004 | 1345 | |
| 2003 | 1000 | |
| 2005 | 478 | 16.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5646 | |
| 2 | 2823 | |
| 4 | 1345 | 11.9% |
| 3 | 1000 | 8.9% |
| 5 | 478 | 4.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 11292 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5646 | |
| 2 | 2823 | |
| 4 | 1345 | 11.9% |
| 3 | 1000 | 8.9% |
| 5 | 478 | 4.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 11292 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5646 | |
| 2 | 2823 | |
| 4 | 1345 | 11.9% |
| 3 | 1000 | 8.9% |
| 5 | 478 | 4.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 11292 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5646 | |
| 2 | 2823 | |
| 4 | 1345 | 11.9% |
| 3 | 1000 | 8.9% |
| 5 | 478 | 4.2% |
PRODUCTLINE
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 22.2 KiB |
| Classic Cars | |
|---|---|
| Vintage Cars | |
| Motorcycles | |
| Planes | |
| Trucks and Buses | |
| Other values (2) |
Length
| Max length | 16 |
|---|---|
| Median length | 12 |
| Mean length | 10.914984 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Motorcycles |
|---|---|
| 2nd row | Motorcycles |
| 3rd row | Motorcycles |
| 4th row | Motorcycles |
| 5th row | Motorcycles |
Common Values
| Value | Count | Frequency (%) |
| Classic Cars | 967 | |
| Vintage Cars | 607 | |
| Motorcycles | 331 | 11.7% |
| Planes | 306 | 10.8% |
| Trucks and Buses | 301 | 10.7% |
| Ships | 234 | 8.3% |
| Trains | 77 | 2.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| cars | 1574 | |
| classic | 967 | |
| vintage | 607 | 12.1% |
| motorcycles | 331 | 6.6% |
| planes | 306 | 6.1% |
| trucks | 301 | 6.0% |
| and | 301 | 6.0% |
| buses | 301 | 6.0% |
| ships | 234 | 4.7% |
| trains | 77 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 5359 | |
| a | 3832 | |
| C | 2541 | 8.2% |
| r | 2283 | 7.4% |
| 2176 | 7.1% | |
| c | 1930 | 6.3% |
| i | 1885 | 6.1% |
| l | 1604 | 5.2% |
| e | 1545 | 5.0% |
| n | 1291 | 4.2% |
| Other values (15) | 6367 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 30813 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 5359 | |
| a | 3832 | |
| C | 2541 | 8.2% |
| r | 2283 | 7.4% |
| 2176 | 7.1% | |
| c | 1930 | 6.3% |
| i | 1885 | 6.1% |
| l | 1604 | 5.2% |
| e | 1545 | 5.0% |
| n | 1291 | 4.2% |
| Other values (15) | 6367 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 30813 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 5359 | |
| a | 3832 | |
| C | 2541 | 8.2% |
| r | 2283 | 7.4% |
| 2176 | 7.1% | |
| c | 1930 | 6.3% |
| i | 1885 | 6.1% |
| l | 1604 | 5.2% |
| e | 1545 | 5.0% |
| n | 1291 | 4.2% |
| Other values (15) | 6367 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 30813 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 5359 | |
| a | 3832 | |
| C | 2541 | 8.2% |
| r | 2283 | 7.4% |
| 2176 | 7.1% | |
| c | 1930 | 6.3% |
| i | 1885 | 6.1% |
| l | 1604 | 5.2% |
| e | 1545 | 5.0% |
| n | 1291 | 4.2% |
| Other values (15) | 6367 |
MSRP
Real number (ℝ)
High correlation
| Distinct | 80 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 100.71555 |
| Minimum | 33 |
|---|---|
| Maximum | 214 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.2 KiB |
Quantile statistics
| Minimum | 33 |
|---|---|
| 5-th percentile | 43 |
| Q1 | 68 |
| median | 99 |
| Q3 | 124 |
| 95-th percentile | 170 |
| Maximum | 214 |
| Range | 181 |
| Interquartile range (IQR) | 56 |
Descriptive statistics
| Standard deviation | 40.187912 |
|---|---|
| Coefficient of variation (CV) | 0.3990239 |
| Kurtosis | -0.13181452 |
| Mean | 100.71555 |
| Median Absolute Deviation (MAD) | 28 |
| Skewness | 0.58017505 |
| Sum | 284320 |
| Variance | 1615.0682 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 118 | 104 | 3.7% |
| 99 | 103 | 3.6% |
| 136 | 80 | 2.8% |
| 62 | 78 | 2.8% |
| 68 | 77 | 2.7% |
| 60 | 76 | 2.7% |
| 80 | 73 | 2.6% |
| 115 | 54 | 1.9% |
| 101 | 54 | 1.9% |
| 54 | 54 | 1.9% |
| Other values (70) | 2070 |
| Value | Count | Frequency (%) |
| 33 | 25 | |
| 35 | 28 | |
| 37 | 27 | |
| 40 | 25 | |
| 41 | 22 | |
| 43 | 26 | |
| 44 | 25 | |
| 49 | 27 | |
| 50 | 51 | |
| 53 | 26 |
| Value | Count | Frequency (%) |
| 214 | 28 | |
| 207 | 26 | |
| 194 | 25 | |
| 193 | 26 | |
| 173 | 26 | |
| 170 | 22 | |
| 169 | 52 | |
| 168 | 26 | |
| 163 | 27 | |
| 157 | 26 |
PRODUCTCODE
Text
| Distinct | 109 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 22.2 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 8.110875 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | S10_1678 |
|---|---|
| 2nd row | S10_1678 |
| 3rd row | S10_1678 |
| 4th row | S10_1678 |
| 5th row | S10_1678 |
| Value | Count | Frequency (%) |
| s18_3232 | 52 | 1.8% |
| s12_1666 | 28 | 1.0% |
| s10_4962 | 28 | 1.0% |
| s18_1097 | 28 | 1.0% |
| s10_1949 | 28 | 1.0% |
| s18_2432 | 28 | 1.0% |
| s32_2509 | 28 | 1.0% |
| s24_2840 | 28 | 1.0% |
| s24_1444 | 28 | 1.0% |
| s50_1392 | 28 | 1.0% |
| Other values (99) | 2519 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 3209 | |
| 1 | 2854 | |
| _ | 2823 | |
| S | 2823 | |
| 4 | 2015 | |
| 8 | 2007 | |
| 0 | 1799 | |
| 3 | 1713 | |
| 7 | 1075 | 4.7% |
| 9 | 949 | 4.1% |
| Other values (2) | 1630 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 22897 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 3209 | |
| 1 | 2854 | |
| _ | 2823 | |
| S | 2823 | |
| 4 | 2015 | |
| 8 | 2007 | |
| 0 | 1799 | |
| 3 | 1713 | |
| 7 | 1075 | 4.7% |
| 9 | 949 | 4.1% |
| Other values (2) | 1630 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 22897 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 3209 | |
| 1 | 2854 | |
| _ | 2823 | |
| S | 2823 | |
| 4 | 2015 | |
| 8 | 2007 | |
| 0 | 1799 | |
| 3 | 1713 | |
| 7 | 1075 | 4.7% |
| 9 | 949 | 4.1% |
| Other values (2) | 1630 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 22897 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 3209 | |
| 1 | 2854 | |
| _ | 2823 | |
| S | 2823 | |
| 4 | 2015 | |
| 8 | 2007 | |
| 0 | 1799 | |
| 3 | 1713 | |
| 7 | 1075 | 4.7% |
| 9 | 949 | 4.1% |
| Other values (2) | 1630 |
CUSTOMERNAME
Text
| Distinct | 92 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 22.2 KiB |
Length
| Max length | 34 |
|---|---|
| Median length | 26 |
| Mean length | 20.972724 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Land of Toys Inc. |
|---|---|
| 2nd row | Reims Collectables |
| 3rd row | Lyon Souveniers |
| 4th row | Toys4GrownUps.com |
| 5th row | Corporate Gift Ideas Co. |
| Value | Count | Frequency (%) |
| co | 665 | 7.6% |
| ltd | 544 | 6.2% |
| gifts | 410 | 4.7% |
| mini | 393 | 4.5% |
| inc | 388 | 4.4% |
| collectables | 334 | 3.8% |
| shopping | 281 | 3.2% |
| euro | 259 | 2.9% |
| channel | 259 | 2.9% |
| gift | 237 | 2.7% |
| Other values (136) | 5023 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5970 | 10.1% | |
| o | 4285 | 7.2% |
| i | 4157 | 7.0% |
| e | 4015 | 6.8% |
| s | 3647 | 6.2% |
| n | 3469 | 5.9% |
| t | 3444 | 5.8% |
| a | 3083 | 5.2% |
| l | 2886 | 4.9% |
| r | 2405 | 4.1% |
| Other values (45) | 21845 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 59206 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 5970 | 10.1% | |
| o | 4285 | 7.2% |
| i | 4157 | 7.0% |
| e | 4015 | 6.8% |
| s | 3647 | 6.2% |
| n | 3469 | 5.9% |
| t | 3444 | 5.8% |
| a | 3083 | 5.2% |
| l | 2886 | 4.9% |
| r | 2405 | 4.1% |
| Other values (45) | 21845 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 59206 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 5970 | 10.1% | |
| o | 4285 | 7.2% |
| i | 4157 | 7.0% |
| e | 4015 | 6.8% |
| s | 3647 | 6.2% |
| n | 3469 | 5.9% |
| t | 3444 | 5.8% |
| a | 3083 | 5.2% |
| l | 2886 | 4.9% |
| r | 2405 | 4.1% |
| Other values (45) | 21845 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 59206 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 5970 | 10.1% | |
| o | 4285 | 7.2% |
| i | 4157 | 7.0% |
| e | 4015 | 6.8% |
| s | 3647 | 6.2% |
| n | 3469 | 5.9% |
| t | 3444 | 5.8% |
| a | 3083 | 5.2% |
| l | 2886 | 4.9% |
| r | 2405 | 4.1% |
| Other values (45) | 21845 |
PHONE
Text
| Distinct | 91 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 22.2 KiB |
Length
| Max length | 17 |
|---|---|
| Median length | 10 |
| Mean length | 11.636557 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2125557818 |
|---|---|
| 2nd row | 26.47.1555 |
| 3rd row | +33 1 46 62 7555 |
| 4th row | 6265557265 |
| 5th row | 6505551386 |
| Value | Count | Frequency (%) |
| 555 | 375 | 6.7% |
| 91 | 291 | 5.2% |
| 94 | 259 | 4.6% |
| 44 | 259 | 4.6% |
| 4155551450 | 180 | 3.2% |
| 8555 | 122 | 2.2% |
| 171 | 118 | 2.1% |
| 3555 | 82 | 1.5% |
| 65 | 79 | 1.4% |
| 4555 | 78 | 1.4% |
| Other values (127) | 3750 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 10957 | |
| 2770 | 8.4% | |
| 4 | 2554 | 7.8% |
| 1 | 2528 | 7.7% |
| 2 | 2161 | 6.6% |
| 9 | 1685 | 5.1% |
| 6 | 1685 | 5.1% |
| 0 | 1623 | 4.9% |
| 8 | 1476 | 4.5% |
| 3 | 1285 | 3.9% |
| Other values (6) | 4126 | 12.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 32850 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 5 | 10957 | |
| 2770 | 8.4% | |
| 4 | 2554 | 7.8% |
| 1 | 2528 | 7.7% |
| 2 | 2161 | 6.6% |
| 9 | 1685 | 5.1% |
| 6 | 1685 | 5.1% |
| 0 | 1623 | 4.9% |
| 8 | 1476 | 4.5% |
| 3 | 1285 | 3.9% |
| Other values (6) | 4126 | 12.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 32850 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 5 | 10957 | |
| 2770 | 8.4% | |
| 4 | 2554 | 7.8% |
| 1 | 2528 | 7.7% |
| 2 | 2161 | 6.6% |
| 9 | 1685 | 5.1% |
| 6 | 1685 | 5.1% |
| 0 | 1623 | 4.9% |
| 8 | 1476 | 4.5% |
| 3 | 1285 | 3.9% |
| Other values (6) | 4126 | 12.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 32850 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 5 | 10957 | |
| 2770 | 8.4% | |
| 4 | 2554 | 7.8% |
| 1 | 2528 | 7.7% |
| 2 | 2161 | 6.6% |
| 9 | 1685 | 5.1% |
| 6 | 1685 | 5.1% |
| 0 | 1623 | 4.9% |
| 8 | 1476 | 4.5% |
| 3 | 1285 | 3.9% |
| Other values (6) | 4126 | 12.6% |
ADDRESSLINE1
Text
| Distinct | 92 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 22.2 KiB |
Length
| Max length | 42 |
|---|---|
| Median length | 36 |
| Mean length | 19.445979 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 897 Long Airport Avenue |
|---|---|
| 2nd row | 59 rue de l'Abbaye |
| 3rd row | 27 rue du Colonel Pierre Avia |
| 4th row | 78934 Hillside Dr. |
| 5th row | 7734 Strong St. |
| Value | Count | Frequency (%) |
| st | 442 | 4.6% |
| c | 306 | 3.2% |
| rue | 281 | 2.9% |
| moralzarzal | 259 | 2.7% |
| 86 | 259 | 2.7% |
| strong | 250 | 2.6% |
| street | 216 | 2.2% |
| 5677 | 180 | 1.9% |
| furth | 135 | 1.4% |
| circle | 135 | 1.4% |
| Other values (210) | 7216 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6904 | 12.6% | |
| e | 3914 | 7.1% |
| r | 3579 | 6.5% |
| a | 2883 | 5.3% |
| t | 2545 | 4.6% |
| n | 2485 | 4.5% |
| o | 2437 | 4.4% |
| l | 1979 | 3.6% |
| i | 1901 | 3.5% |
| u | 1438 | 2.6% |
| Other values (57) | 24831 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 54896 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 6904 | 12.6% | |
| e | 3914 | 7.1% |
| r | 3579 | 6.5% |
| a | 2883 | 5.3% |
| t | 2545 | 4.6% |
| n | 2485 | 4.5% |
| o | 2437 | 4.4% |
| l | 1979 | 3.6% |
| i | 1901 | 3.5% |
| u | 1438 | 2.6% |
| Other values (57) | 24831 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 54896 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 6904 | 12.6% | |
| e | 3914 | 7.1% |
| r | 3579 | 6.5% |
| a | 2883 | 5.3% |
| t | 2545 | 4.6% |
| n | 2485 | 4.5% |
| o | 2437 | 4.4% |
| l | 1979 | 3.6% |
| i | 1901 | 3.5% |
| u | 1438 | 2.6% |
| Other values (57) | 24831 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 54896 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 6904 | 12.6% | |
| e | 3914 | 7.1% |
| r | 3579 | 6.5% |
| a | 2883 | 5.3% |
| t | 2545 | 4.6% |
| n | 2485 | 4.5% |
| o | 2437 | 4.4% |
| l | 1979 | 3.6% |
| i | 1901 | 3.5% |
| u | 1438 | 2.6% |
| Other values (57) | 24831 |
ADDRESSLINE2
Categorical
High correlation Missing
| Distinct | 9 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 2521 |
| Missing (%) | 89.3% |
| Memory size | 22.2 KiB |
| Level 3 | |
|---|---|
| Suite 400 | |
| Level 6 | |
| Level 15 | |
| 2nd Floor | |
| Other values (4) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.2847682 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Level 3 |
|---|---|
| 2nd row | Suite 101 |
| 3rd row | Level 6 |
| 4th row | Suite 750 |
| 5th row | Level 6 |
Common Values
| Value | Count | Frequency (%) |
| Level 3 | 55 | 1.9% |
| Suite 400 | 48 | 1.7% |
| Level 6 | 46 | 1.6% |
| Level 15 | 46 | 1.6% |
| 2nd Floor | 36 | 1.3% |
| Suite 101 | 25 | 0.9% |
| Suite 750 | 20 | 0.7% |
| Floor No. 4 | 16 | 0.6% |
| Suite 200 | 10 | 0.4% |
| (Missing) | 2521 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| level | 147 | |
| suite | 103 | |
| 3 | 55 | 8.9% |
| floor | 52 | 8.4% |
| 400 | 48 | 7.7% |
| 6 | 46 | 7.4% |
| 15 | 46 | 7.4% |
| 2nd | 36 | 5.8% |
| 101 | 25 | 4.0% |
| 750 | 20 | 3.2% |
| Other values (3) | 42 | 6.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 397 | |
| 318 | ||
| l | 199 | 8.0% |
| 0 | 161 | 6.4% |
| v | 147 | 5.9% |
| L | 147 | 5.9% |
| o | 120 | 4.8% |
| S | 103 | 4.1% |
| t | 103 | 4.1% |
| u | 103 | 4.1% |
| Other values (14) | 704 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2502 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 397 | |
| 318 | ||
| l | 199 | 8.0% |
| 0 | 161 | 6.4% |
| v | 147 | 5.9% |
| L | 147 | 5.9% |
| o | 120 | 4.8% |
| S | 103 | 4.1% |
| t | 103 | 4.1% |
| u | 103 | 4.1% |
| Other values (14) | 704 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2502 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 397 | |
| 318 | ||
| l | 199 | 8.0% |
| 0 | 161 | 6.4% |
| v | 147 | 5.9% |
| L | 147 | 5.9% |
| o | 120 | 4.8% |
| S | 103 | 4.1% |
| t | 103 | 4.1% |
| u | 103 | 4.1% |
| Other values (14) | 704 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2502 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 397 | |
| 318 | ||
| l | 199 | 8.0% |
| 0 | 161 | 6.4% |
| v | 147 | 5.9% |
| L | 147 | 5.9% |
| o | 120 | 4.8% |
| S | 103 | 4.1% |
| t | 103 | 4.1% |
| u | 103 | 4.1% |
| Other values (14) | 704 |
CITY
Text
| Distinct | 73 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 22.2 KiB |
Length
| Max length | 14 |
|---|---|
| Median length | 12 |
| Mean length | 7.7530995 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | NYC |
|---|---|
| 2nd row | Reims |
| 3rd row | Paris |
| 4th row | Pasadena |
| 5th row | San Francisco |
| Value | Count | Frequency (%) |
| san | 307 | 9.0% |
| madrid | 304 | 8.9% |
| rafael | 180 | 5.3% |
| nyc | 152 | 4.4% |
| singapore | 79 | 2.3% |
| new | 78 | 2.3% |
| paris | 70 | 2.0% |
| francisco | 62 | 1.8% |
| bedford | 61 | 1.8% |
| nantes | 60 | 1.8% |
| Other values (72) | 2073 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2614 | 11.9% |
| e | 2008 | 9.2% |
| n | 1562 | 7.1% |
| r | 1501 | 6.9% |
| i | 1327 | 6.1% |
| o | 1298 | 5.9% |
| l | 1083 | 4.9% |
| s | 1049 | 4.8% |
| d | 1019 | 4.7% |
| 603 | 2.8% | |
| Other values (37) | 7823 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 21887 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 2614 | 11.9% |
| e | 2008 | 9.2% |
| n | 1562 | 7.1% |
| r | 1501 | 6.9% |
| i | 1327 | 6.1% |
| o | 1298 | 5.9% |
| l | 1083 | 4.9% |
| s | 1049 | 4.8% |
| d | 1019 | 4.7% |
| 603 | 2.8% | |
| Other values (37) | 7823 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 21887 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 2614 | 11.9% |
| e | 2008 | 9.2% |
| n | 1562 | 7.1% |
| r | 1501 | 6.9% |
| i | 1327 | 6.1% |
| o | 1298 | 5.9% |
| l | 1083 | 4.9% |
| s | 1049 | 4.8% |
| d | 1019 | 4.7% |
| 603 | 2.8% | |
| Other values (37) | 7823 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 21887 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 2614 | 11.9% |
| e | 2008 | 9.2% |
| n | 1562 | 7.1% |
| r | 1501 | 6.9% |
| i | 1327 | 6.1% |
| o | 1298 | 5.9% |
| l | 1083 | 4.9% |
| s | 1049 | 4.8% |
| d | 1019 | 4.7% |
| 603 | 2.8% | |
| Other values (37) | 7823 |
STATE
Categorical
High correlation Missing
| Distinct | 16 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 1486 |
| Missing (%) | 52.6% |
| Memory size | 22.2 KiB |
| CA | |
|---|---|
| MA | |
| NY | |
| NSW | |
| Victoria | |
| Other values (11) |
Length
| Max length | 13 |
|---|---|
| Median length | 2 |
| Mean length | 2.9050112 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | NY |
|---|---|
| 2nd row | CA |
| 3rd row | CA |
| 4th row | CA |
| 5th row | CA |
Common Values
| Value | Count | Frequency (%) |
| CA | 416 | 14.7% |
| MA | 190 | 6.7% |
| NY | 178 | 6.3% |
| NSW | 92 | 3.3% |
| Victoria | 78 | 2.8% |
| PA | 75 | 2.7% |
| CT | 61 | 2.2% |
| BC | 48 | 1.7% |
| NH | 34 | 1.2% |
| Tokyo | 32 | 1.1% |
| Other values (6) | 133 | 4.7% |
| (Missing) | 1486 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| ca | 416 | |
| ma | 190 | |
| ny | 178 | |
| nsw | 92 | 6.6% |
| victoria | 78 | 5.6% |
| pa | 75 | 5.4% |
| ct | 61 | 4.4% |
| bc | 48 | 3.5% |
| nh | 34 | 2.4% |
| tokyo | 32 | 2.3% |
| Other values (8) | 185 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 681 | |
| C | 525 | |
| N | 354 | 9.1% |
| M | 190 | 4.9% |
| i | 182 | 4.7% |
| Y | 178 | 4.6% |
| o | 168 | 4.3% |
| a | 133 | 3.4% |
| W | 118 | 3.0% |
| V | 107 | 2.8% |
| Other values (25) | 1248 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3884 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 681 | |
| C | 525 | |
| N | 354 | 9.1% |
| M | 190 | 4.9% |
| i | 182 | 4.7% |
| Y | 178 | 4.6% |
| o | 168 | 4.3% |
| a | 133 | 3.4% |
| W | 118 | 3.0% |
| V | 107 | 2.8% |
| Other values (25) | 1248 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3884 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 681 | |
| C | 525 | |
| N | 354 | 9.1% |
| M | 190 | 4.9% |
| i | 182 | 4.7% |
| Y | 178 | 4.6% |
| o | 168 | 4.3% |
| a | 133 | 3.4% |
| W | 118 | 3.0% |
| V | 107 | 2.8% |
| Other values (25) | 1248 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3884 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 681 | |
| C | 525 | |
| N | 354 | 9.1% |
| M | 190 | 4.9% |
| i | 182 | 4.7% |
| Y | 178 | 4.6% |
| o | 168 | 4.3% |
| a | 133 | 3.4% |
| W | 118 | 3.0% |
| V | 107 | 2.8% |
| Other values (25) | 1248 |
POSTALCODE
Text
Missing
| Distinct | 73 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 76 |
| Missing (%) | 2.7% |
| Memory size | 22.2 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.2133236 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 10022 |
|---|---|
| 2nd row | 51100 |
| 3rd row | 75508 |
| 4th row | 90003 |
| 5th row | 94217 |
| Value | Count | Frequency (%) |
| 28034 | 259 | 8.4% |
| 97562 | 205 | 6.6% |
| 10022 | 152 | 4.9% |
| 94217 | 89 | 2.9% |
| 50553 | 61 | 2.0% |
| 44000 | 60 | 1.9% |
| 3004 | 55 | 1.8% |
| n | 53 | 1.7% |
| ec2 | 51 | 1.6% |
| 5nt | 51 | 1.6% |
| Other values (75) | 2061 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 3173 | |
| 2 | 1890 | |
| 1 | 1434 | |
| 4 | 1044 | 7.3% |
| 3 | 1035 | 7.2% |
| 5 | 990 | 6.9% |
| 7 | 947 | 6.6% |
| 9 | 763 | 5.3% |
| 6 | 740 | 5.2% |
| 8 | 712 | 5.0% |
| Other values (22) | 1593 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 14321 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3173 | |
| 2 | 1890 | |
| 1 | 1434 | |
| 4 | 1044 | 7.3% |
| 3 | 1035 | 7.2% |
| 5 | 990 | 6.9% |
| 7 | 947 | 6.6% |
| 9 | 763 | 5.3% |
| 6 | 740 | 5.2% |
| 8 | 712 | 5.0% |
| Other values (22) | 1593 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 14321 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3173 | |
| 2 | 1890 | |
| 1 | 1434 | |
| 4 | 1044 | 7.3% |
| 3 | 1035 | 7.2% |
| 5 | 990 | 6.9% |
| 7 | 947 | 6.6% |
| 9 | 763 | 5.3% |
| 6 | 740 | 5.2% |
| 8 | 712 | 5.0% |
| Other values (22) | 1593 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 14321 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3173 | |
| 2 | 1890 | |
| 1 | 1434 | |
| 4 | 1044 | 7.3% |
| 3 | 1035 | 7.2% |
| 5 | 990 | 6.9% |
| 7 | 947 | 6.6% |
| 9 | 763 | 5.3% |
| 6 | 740 | 5.2% |
| 8 | 712 | 5.0% |
| Other values (22) | 1593 |
COUNTRY
Categorical
High correlation
| Distinct | 19 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 22.2 KiB |
| USA | |
|---|---|
| Spain | |
| France | |
| Australia | |
| UK | |
| Other values (14) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 5.0446334 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USA |
|---|---|
| 2nd row | France |
| 3rd row | France |
| 4th row | USA |
| 5th row | USA |
Common Values
| Value | Count | Frequency (%) |
| USA | 1004 | |
| Spain | 342 | 12.1% |
| France | 314 | 11.1% |
| Australia | 185 | 6.6% |
| UK | 144 | 5.1% |
| Italy | 113 | 4.0% |
| Finland | 92 | 3.3% |
| Norway | 85 | 3.0% |
| Singapore | 79 | 2.8% |
| Canada | 70 | 2.5% |
| Other values (9) | 395 | 14.0% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| usa | 1004 | |
| spain | 342 | 12.1% |
| france | 314 | 11.1% |
| australia | 185 | 6.6% |
| uk | 144 | 5.1% |
| italy | 113 | 4.0% |
| finland | 92 | 3.3% |
| norway | 85 | 3.0% |
| singapore | 79 | 2.8% |
| canada | 70 | 2.5% |
| Other values (9) | 395 | 14.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1936 | |
| S | 1513 | |
| n | 1296 | 9.1% |
| A | 1244 | 8.7% |
| U | 1148 | 8.1% |
| i | 895 | 6.3% |
| r | 890 | 6.2% |
| e | 738 | 5.2% |
| p | 525 | 3.7% |
| l | 496 | 3.5% |
| Other values (23) | 3560 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 14241 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 1936 | |
| S | 1513 | |
| n | 1296 | 9.1% |
| A | 1244 | 8.7% |
| U | 1148 | 8.1% |
| i | 895 | 6.3% |
| r | 890 | 6.2% |
| e | 738 | 5.2% |
| p | 525 | 3.7% |
| l | 496 | 3.5% |
| Other values (23) | 3560 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 14241 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 1936 | |
| S | 1513 | |
| n | 1296 | 9.1% |
| A | 1244 | 8.7% |
| U | 1148 | 8.1% |
| i | 895 | 6.3% |
| r | 890 | 6.2% |
| e | 738 | 5.2% |
| p | 525 | 3.7% |
| l | 496 | 3.5% |
| Other values (23) | 3560 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 14241 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 1936 | |
| S | 1513 | |
| n | 1296 | 9.1% |
| A | 1244 | 8.7% |
| U | 1148 | 8.1% |
| i | 895 | 6.3% |
| r | 890 | 6.2% |
| e | 738 | 5.2% |
| p | 525 | 3.7% |
| l | 496 | 3.5% |
| Other values (23) | 3560 |
TERRITORY
Categorical
High correlation Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1074 |
| Missing (%) | 38.0% |
| Memory size | 22.2 KiB |
| EMEA | |
|---|---|
| APAC | |
| Japan | 121 |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 4.0691824 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | EMEA |
|---|---|
| 2nd row | EMEA |
| 3rd row | EMEA |
| 4th row | EMEA |
| 5th row | EMEA |
Common Values
| Value | Count | Frequency (%) |
| EMEA | 1407 | |
| APAC | 221 | 7.8% |
| Japan | 121 | 4.3% |
| (Missing) | 1074 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| emea | 1407 | |
| apac | 221 | 12.6% |
| japan | 121 | 6.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 2814 | |
| A | 1849 | |
| M | 1407 | |
| a | 242 | 3.4% |
| P | 221 | 3.1% |
| C | 221 | 3.1% |
| J | 121 | 1.7% |
| p | 121 | 1.7% |
| n | 121 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7117 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 2814 | |
| A | 1849 | |
| M | 1407 | |
| a | 242 | 3.4% |
| P | 221 | 3.1% |
| C | 221 | 3.1% |
| J | 121 | 1.7% |
| p | 121 | 1.7% |
| n | 121 | 1.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7117 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 2814 | |
| A | 1849 | |
| M | 1407 | |
| a | 242 | 3.4% |
| P | 221 | 3.1% |
| C | 221 | 3.1% |
| J | 121 | 1.7% |
| p | 121 | 1.7% |
| n | 121 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7117 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 2814 | |
| A | 1849 | |
| M | 1407 | |
| a | 242 | 3.4% |
| P | 221 | 3.1% |
| C | 221 | 3.1% |
| J | 121 | 1.7% |
| p | 121 | 1.7% |
| n | 121 | 1.7% |
CONTACTLASTNAME
Text
| Distinct | 77 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 22.2 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 6.4413744 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Yu |
|---|---|
| 2nd row | Henriot |
| 3rd row | Da Cunha |
| 4th row | Young |
| 5th row | Brown |
| Value | Count | Frequency (%) |
| freyre | 259 | 9.1% |
| nelson | 204 | 7.2% |
| young | 115 | 4.0% |
| frick | 91 | 3.2% |
| brown | 88 | 3.1% |
| yu | 80 | 2.8% |
| hernandez | 70 | 2.5% |
| ferguson | 55 | 1.9% |
| king | 54 | 1.9% |
| labrune | 53 | 1.9% |
| Other values (68) | 1774 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 2297 | 12.6% |
| r | 1850 | 10.2% |
| n | 1769 | 9.7% |
| o | 1355 | 7.5% |
| a | 1137 | 6.3% |
| i | 952 | 5.2% |
| s | 759 | 4.2% |
| l | 701 | 3.9% |
| u | 647 | 3.6% |
| t | 579 | 3.2% |
| Other values (35) | 6138 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 18184 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 2297 | 12.6% |
| r | 1850 | 10.2% |
| n | 1769 | 9.7% |
| o | 1355 | 7.5% |
| a | 1137 | 6.3% |
| i | 952 | 5.2% |
| s | 759 | 4.2% |
| l | 701 | 3.9% |
| u | 647 | 3.6% |
| t | 579 | 3.2% |
| Other values (35) | 6138 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 18184 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 2297 | 12.6% |
| r | 1850 | 10.2% |
| n | 1769 | 9.7% |
| o | 1355 | 7.5% |
| a | 1137 | 6.3% |
| i | 952 | 5.2% |
| s | 759 | 4.2% |
| l | 701 | 3.9% |
| u | 647 | 3.6% |
| t | 579 | 3.2% |
| Other values (35) | 6138 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 18184 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 2297 | 12.6% |
| r | 1850 | 10.2% |
| n | 1769 | 9.7% |
| o | 1355 | 7.5% |
| a | 1137 | 6.3% |
| i | 952 | 5.2% |
| s | 759 | 4.2% |
| l | 701 | 3.9% |
| u | 647 | 3.6% |
| t | 579 | 3.2% |
| Other values (35) | 6138 |
CONTACTFIRSTNAME
Text
| Distinct | 72 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 22.2 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 5.6680836 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Kwai |
|---|---|
| 2nd row | Paul |
| 3rd row | Daniel |
| 4th row | Julie |
| 5th row | Julie |
| Value | Count | Frequency (%) |
| diego | 259 | 9.0% |
| valarie | 257 | 8.9% |
| julie | 117 | 4.1% |
| michael | 84 | 2.9% |
| sue | 84 | 2.9% |
| juri | 60 | 2.1% |
| maria | 58 | 2.0% |
| elizabeth | 55 | 1.9% |
| peter | 55 | 1.9% |
| janine | 53 | 1.8% |
| Other values (64) | 1791 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 2067 | |
| i | 1890 | |
| a | 1875 | 11.7% |
| r | 1069 | 6.7% |
| n | 1049 | 6.6% |
| l | 1017 | 6.4% |
| o | 846 | 5.3% |
| t | 573 | 3.6% |
| u | 505 | 3.2% |
| J | 420 | 2.6% |
| Other values (33) | 4690 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 16001 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 2067 | |
| i | 1890 | |
| a | 1875 | 11.7% |
| r | 1069 | 6.7% |
| n | 1049 | 6.6% |
| l | 1017 | 6.4% |
| o | 846 | 5.3% |
| t | 573 | 3.6% |
| u | 505 | 3.2% |
| J | 420 | 2.6% |
| Other values (33) | 4690 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 16001 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 2067 | |
| i | 1890 | |
| a | 1875 | 11.7% |
| r | 1069 | 6.7% |
| n | 1049 | 6.6% |
| l | 1017 | 6.4% |
| o | 846 | 5.3% |
| t | 573 | 3.6% |
| u | 505 | 3.2% |
| J | 420 | 2.6% |
| Other values (33) | 4690 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 16001 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 2067 | |
| i | 1890 | |
| a | 1875 | 11.7% |
| r | 1069 | 6.7% |
| n | 1049 | 6.6% |
| l | 1017 | 6.4% |
| o | 846 | 5.3% |
| t | 573 | 3.6% |
| u | 505 | 3.2% |
| J | 420 | 2.6% |
| Other values (33) | 4690 |
DEALSIZE
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 22.2 KiB |
| Medium | |
|---|---|
| Small | |
| Large |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.4902586 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Small |
|---|---|
| 2nd row | Small |
| 3rd row | Medium |
| 4th row | Medium |
| 5th row | Medium |
Common Values
| Value | Count | Frequency (%) |
| Medium | 1384 | |
| Small | 1282 | |
| Large | 157 | 5.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| medium | 1384 | |
| small | 1282 | |
| large | 157 | 5.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| m | 2666 | |
| l | 2564 | |
| e | 1541 | |
| a | 1439 | |
| i | 1384 | |
| d | 1384 | |
| M | 1384 | |
| u | 1384 | |
| S | 1282 | |
| L | 157 | 1.0% |
| Other values (2) | 314 | 2.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 15499 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| m | 2666 | |
| l | 2564 | |
| e | 1541 | |
| a | 1439 | |
| i | 1384 | |
| d | 1384 | |
| M | 1384 | |
| u | 1384 | |
| S | 1282 | |
| L | 157 | 1.0% |
| Other values (2) | 314 | 2.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 15499 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| m | 2666 | |
| l | 2564 | |
| e | 1541 | |
| a | 1439 | |
| i | 1384 | |
| d | 1384 | |
| M | 1384 | |
| u | 1384 | |
| S | 1282 | |
| L | 157 | 1.0% |
| Other values (2) | 314 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 15499 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| m | 2666 | |
| l | 2564 | |
| e | 1541 | |
| a | 1439 | |
| i | 1384 | |
| d | 1384 | |
| M | 1384 | |
| u | 1384 | |
| S | 1282 | |
| L | 157 | 1.0% |
| Other values (2) | 314 | 2.0% |
Interactions
Correlations
| ADDRESSLINE2 | COUNTRY | DEALSIZE | MONTH_ID | MSRP | ORDERLINENUMBER | ORDERNUMBER | PRICEEACH | PRODUCTLINE | QTR_ID | QUANTITYORDERED | SALES | STATE | STATUS | TERRITORY | YEAR_ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ADDRESSLINE2 | 1.000 | 0.992 | 0.000 | 0.461 | 0.000 | 0.000 | 0.532 | 0.000 | 0.316 | 0.402 | 0.063 | 0.000 | 0.992 | 0.474 | 0.992 | 0.529 |
| COUNTRY | 0.992 | 1.000 | 0.000 | 0.253 | 0.000 | 0.000 | 0.257 | 0.018 | 0.157 | 0.236 | 0.041 | 0.000 | 0.996 | 0.207 | 0.931 | 0.224 |
| DEALSIZE | 0.000 | 0.000 | 1.000 | 0.041 | 0.484 | 0.044 | 0.037 | 0.481 | 0.148 | 0.035 | 0.365 | 0.898 | 0.031 | 0.066 | 0.000 | 0.035 |
| MONTH_ID | 0.461 | 0.253 | 0.041 | 1.000 | 0.008 | 0.032 | -0.012 | 0.011 | 0.038 | 0.999 | -0.026 | -0.002 | 0.308 | 0.283 | 0.166 | 0.414 |
| MSRP | 0.000 | 0.000 | 0.484 | 0.008 | 1.000 | -0.014 | -0.010 | 0.756 | 0.319 | 0.000 | 0.018 | 0.665 | 0.000 | 0.000 | 0.000 | 0.000 |
| ORDERLINENUMBER | 0.000 | 0.000 | 0.044 | 0.032 | -0.014 | 1.000 | -0.048 | -0.031 | 0.033 | 0.015 | -0.021 | -0.047 | 0.000 | 0.000 | 0.000 | 0.000 |
| ORDERNUMBER | 0.532 | 0.257 | 0.037 | -0.012 | -0.010 | -0.048 | 1.000 | -0.004 | 0.000 | 0.833 | 0.043 | 0.021 | 0.336 | 0.340 | 0.212 | 0.954 |
| PRICEEACH | 0.000 | 0.018 | 0.481 | 0.011 | 0.756 | -0.031 | -0.004 | 1.000 | 0.146 | 0.023 | 0.006 | 0.788 | 0.000 | 0.034 | 0.005 | 0.016 |
| PRODUCTLINE | 0.316 | 0.157 | 0.148 | 0.038 | 0.319 | 0.033 | 0.000 | 0.146 | 1.000 | 0.020 | 0.000 | 0.112 | 0.180 | 0.093 | 0.110 | 0.005 |
| QTR_ID | 0.402 | 0.236 | 0.035 | 0.999 | 0.000 | 0.015 | 0.833 | 0.023 | 0.020 | 1.000 | 0.139 | 0.021 | 0.356 | 0.248 | 0.068 | 0.380 |
| QUANTITYORDERED | 0.063 | 0.041 | 0.365 | -0.026 | 0.018 | -0.021 | 0.043 | 0.006 | 0.000 | 0.139 | 1.000 | 0.538 | 0.108 | 0.191 | 0.000 | 0.193 |
| SALES | 0.000 | 0.000 | 0.898 | -0.002 | 0.665 | -0.047 | 0.021 | 0.788 | 0.112 | 0.021 | 0.538 | 1.000 | 0.000 | 0.078 | 0.035 | 0.056 |
| STATE | 0.992 | 0.996 | 0.031 | 0.308 | 0.000 | 0.000 | 0.336 | 0.000 | 0.180 | 0.356 | 0.108 | 0.000 | 1.000 | 0.279 | 0.994 | 0.314 |
| STATUS | 0.474 | 0.207 | 0.066 | 0.283 | 0.000 | 0.000 | 0.340 | 0.034 | 0.093 | 0.248 | 0.191 | 0.078 | 0.279 | 1.000 | 0.104 | 0.307 |
| TERRITORY | 0.992 | 0.931 | 0.000 | 0.166 | 0.000 | 0.000 | 0.212 | 0.005 | 0.110 | 0.068 | 0.000 | 0.035 | 0.994 | 0.104 | 1.000 | 0.065 |
| YEAR_ID | 0.529 | 0.224 | 0.035 | 0.414 | 0.000 | 0.000 | 0.954 | 0.016 | 0.005 | 0.380 | 0.193 | 0.056 | 0.314 | 0.307 | 0.065 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| ORDERNUMBER | QUANTITYORDERED | PRICEEACH | ORDERLINENUMBER | SALES | ORDERDATE | STATUS | QTR_ID | MONTH_ID | YEAR_ID | PRODUCTLINE | MSRP | PRODUCTCODE | CUSTOMERNAME | PHONE | ADDRESSLINE1 | ADDRESSLINE2 | CITY | STATE | POSTALCODE | COUNTRY | TERRITORY | CONTACTLASTNAME | CONTACTFIRSTNAME | DEALSIZE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 10107 | 30 | 95.70 | 2 | 2871.00 | 2/24/2003 0:00 | Shipped | 1 | 2 | 2003 | Motorcycles | 95 | S10_1678 | Land of Toys Inc. | 2125557818 | 897 Long Airport Avenue | NaN | NYC | NY | 10022 | USA | NaN | Yu | Kwai | Small |
| 1 | 10121 | 34 | 81.35 | 5 | 2765.90 | 5/7/2003 0:00 | Shipped | 2 | 5 | 2003 | Motorcycles | 95 | S10_1678 | Reims Collectables | 26.47.1555 | 59 rue de l'Abbaye | NaN | Reims | NaN | 51100 | France | EMEA | Henriot | Paul | Small |
| 2 | 10134 | 41 | 94.74 | 2 | 3884.34 | 7/1/2003 0:00 | Shipped | 3 | 7 | 2003 | Motorcycles | 95 | S10_1678 | Lyon Souveniers | +33 1 46 62 7555 | 27 rue du Colonel Pierre Avia | NaN | Paris | NaN | 75508 | France | EMEA | Da Cunha | Daniel | Medium |
| 3 | 10145 | 45 | 83.26 | 6 | 3746.70 | 8/25/2003 0:00 | Shipped | 3 | 8 | 2003 | Motorcycles | 95 | S10_1678 | Toys4GrownUps.com | 6265557265 | 78934 Hillside Dr. | NaN | Pasadena | CA | 90003 | USA | NaN | Young | Julie | Medium |
| 4 | 10159 | 49 | 100.00 | 14 | 5205.27 | 10/10/2003 0:00 | Shipped | 4 | 10 | 2003 | Motorcycles | 95 | S10_1678 | Corporate Gift Ideas Co. | 6505551386 | 7734 Strong St. | NaN | San Francisco | CA | NaN | USA | NaN | Brown | Julie | Medium |
| 5 | 10168 | 36 | 96.66 | 1 | 3479.76 | 10/28/2003 0:00 | Shipped | 4 | 10 | 2003 | Motorcycles | 95 | S10_1678 | Technics Stores Inc. | 6505556809 | 9408 Furth Circle | NaN | Burlingame | CA | 94217 | USA | NaN | Hirano | Juri | Medium |
| 6 | 10180 | 29 | 86.13 | 9 | 2497.77 | 11/11/2003 0:00 | Shipped | 4 | 11 | 2003 | Motorcycles | 95 | S10_1678 | Daedalus Designs Imports | 20.16.1555 | 184, chausse de Tournai | NaN | Lille | NaN | 59000 | France | EMEA | Rance | Martine | Small |
| 7 | 10188 | 48 | 100.00 | 1 | 5512.32 | 11/18/2003 0:00 | Shipped | 4 | 11 | 2003 | Motorcycles | 95 | S10_1678 | Herkku Gifts | +47 2267 3215 | Drammen 121, PR 744 Sentrum | NaN | Bergen | NaN | N 5804 | Norway | EMEA | Oeztan | Veysel | Medium |
| 8 | 10201 | 22 | 98.57 | 2 | 2168.54 | 12/1/2003 0:00 | Shipped | 4 | 12 | 2003 | Motorcycles | 95 | S10_1678 | Mini Wheels Co. | 6505555787 | 5557 North Pendale Street | NaN | San Francisco | CA | NaN | USA | NaN | Murphy | Julie | Small |
| 9 | 10211 | 41 | 100.00 | 14 | 4708.44 | 1/15/2004 0:00 | Shipped | 1 | 1 | 2004 | Motorcycles | 95 | S10_1678 | Auto Canal Petit | (1) 47.55.6555 | 25, rue Lauriston | NaN | Paris | NaN | 75016 | France | EMEA | Perrier | Dominique | Medium |
| ORDERNUMBER | QUANTITYORDERED | PRICEEACH | ORDERLINENUMBER | SALES | ORDERDATE | STATUS | QTR_ID | MONTH_ID | YEAR_ID | PRODUCTLINE | MSRP | PRODUCTCODE | CUSTOMERNAME | PHONE | ADDRESSLINE1 | ADDRESSLINE2 | CITY | STATE | POSTALCODE | COUNTRY | TERRITORY | CONTACTLASTNAME | CONTACTFIRSTNAME | DEALSIZE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2813 | 10293 | 32 | 60.06 | 1 | 1921.92 | 9/9/2004 0:00 | Shipped | 3 | 9 | 2004 | Ships | 54 | S72_3212 | Amica Models & Co. | 011-4988555 | Via Monte Bianco 34 | NaN | Torino | NaN | 10100 | Italy | EMEA | Accorti | Paolo | Small |
| 2814 | 10306 | 35 | 59.51 | 6 | 2082.85 | 10/14/2004 0:00 | Shipped | 4 | 10 | 2004 | Ships | 54 | S72_3212 | AV Stores, Co. | (171) 555-1555 | Fauntleroy Circus | NaN | Manchester | NaN | EC2 5NT | UK | EMEA | Ashworth | Victoria | Small |
| 2815 | 10315 | 40 | 55.69 | 5 | 2227.60 | 10/29/2004 0:00 | Shipped | 4 | 10 | 2004 | Ships | 54 | S72_3212 | La Rochelle Gifts | 40.67.8555 | 67, rue des Cinquante Otages | NaN | Nantes | NaN | 44000 | France | EMEA | Labrune | Janine | Small |
| 2816 | 10327 | 37 | 86.74 | 4 | 3209.38 | 11/10/2004 0:00 | Resolved | 4 | 11 | 2004 | Ships | 54 | S72_3212 | Danish Wholesale Imports | 31 12 3555 | Vinb'ltet 34 | NaN | Kobenhavn | NaN | 1734 | Denmark | EMEA | Petersen | Jytte | Medium |
| 2817 | 10337 | 42 | 97.16 | 5 | 4080.72 | 11/21/2004 0:00 | Shipped | 4 | 11 | 2004 | Ships | 54 | S72_3212 | Classic Legends Inc. | 2125558493 | 5905 Pompton St. | Suite 750 | NYC | NY | 10022 | USA | NaN | Hernandez | Maria | Medium |
| 2818 | 10350 | 20 | 100.00 | 15 | 2244.40 | 12/2/2004 0:00 | Shipped | 4 | 12 | 2004 | Ships | 54 | S72_3212 | Euro Shopping Channel | (91) 555 94 44 | C/ Moralzarzal, 86 | NaN | Madrid | NaN | 28034 | Spain | EMEA | Freyre | Diego | Small |
| 2819 | 10373 | 29 | 100.00 | 1 | 3978.51 | 1/31/2005 0:00 | Shipped | 1 | 1 | 2005 | Ships | 54 | S72_3212 | Oulu Toy Supplies, Inc. | 981-443655 | Torikatu 38 | NaN | Oulu | NaN | 90110 | Finland | EMEA | Koskitalo | Pirkko | Medium |
| 2820 | 10386 | 43 | 100.00 | 4 | 5417.57 | 3/1/2005 0:00 | Resolved | 1 | 3 | 2005 | Ships | 54 | S72_3212 | Euro Shopping Channel | (91) 555 94 44 | C/ Moralzarzal, 86 | NaN | Madrid | NaN | 28034 | Spain | EMEA | Freyre | Diego | Medium |
| 2821 | 10397 | 34 | 62.24 | 1 | 2116.16 | 3/28/2005 0:00 | Shipped | 1 | 3 | 2005 | Ships | 54 | S72_3212 | Alpha Cognac | 61.77.6555 | 1 rue Alsace-Lorraine | NaN | Toulouse | NaN | 31000 | France | EMEA | Roulet | Annette | Small |
| 2822 | 10414 | 47 | 65.52 | 9 | 3079.44 | 5/6/2005 0:00 | On Hold | 2 | 5 | 2005 | Ships | 54 | S72_3212 | Gifts4AllAges.com | 6175559555 | 8616 Spinnaker Dr. | NaN | Boston | MA | 51003 | USA | NaN | Yoshido | Juri | Medium |